Dynamic SQL is a SQL code that your program generates using variables before the SQL is executed. In coldfusion, CFQUERY give full provision to write all conditional logic & looping to derive the dynamic sql statement to execute. You can use dynamic SQL to accomplish tasks such as adding WHERE clauses to a search based on the fields that the user filled out on a search criteria page.
Liked By
Write Answer
How can you create dynamic query?
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
17-May-2011In coldfusion, CFQUERY give full provision to write all conditional logic & looping to derive the dynamic sql statement to execute. You can use dynamic SQL to accomplish tasks such as adding WHERE clauses to a search based on the fields that the user filled out on a search criteria page.